CREATE TABLE [dbo].[Semester]
(
[n_sem] [tinyint] NOT NULL,
[ik_sem_type] [tinyint] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Semester] ADD CONSTRAINT [semNumber] CHECK (([n_sem]>=(1) AND [n_sem]<=(12)))
GO
ALTER TABLE [dbo].[Semester] ADD CONSTRAINT [PK_Semester] PRIMARY KEY CLUSTERED  ([n_sem]) ON [PRIMARY]
GO
